SELECT concat( "", d.demographic_no, "" ) as 'Chart Number', CONCAT(d.last_name,', ', d.first_name) as 'Patient Name', CONCAT(date_of_birth, '-', month_of_birth, '-',year_of_birth, ' ') as 'Date of Birth', CONCAT(' Home: ', d.phone, ' Work: ' , d.phone2) as 'Phone Numbers', CONCAT( "", "eChart", "" ) AS "eChart", e.timeStamp, SUBSTRING(e.Reminders, LOCATE('{searchtext}', e.Reminders), 50) AS SearchTerm, e.Reminders AS REMINDER FROM demographic d JOIN ( SELECT ac.demographicNo, MAX(ac.eChartId) AS 'eChartId' FROM eChart ac GROUP BY ac.demographicNo ) AS aggrChart ON d.demographic_no = aggrChart.demographicNo JOIN eChart e ON e.eChartId = aggrChart.eChartId WHERE d.patient_status = 'AC' AND e.Reminders like '%{searchtext}%' ORDER by e.timeStamp DESC